Skip to main content Skip to sidebar content
Libraries & Locations Borrowing Course Guides Research Help

Databases by Type

Error No: 1064 - MySQL error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by i.name' at line 1
Query:
SELECT i.ID,i.name,i.description,i.URL,i.full,i.coverage from item i left join t_bridge b on i.ID=b.ID left join type t on b.TID=t.TID where i.status = 'a' and i.active = 'y' and t.TID =4% order by i.name
#0 {main}